package com.bw.gmallapi.mapper;

import com.bw.gmallapi.entity.ProvinceBean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

@Mapper
public interface ProvinceMapper {

    @Select("select province_name,sum(order_amount) order_amount from province_2203A where toYYYYMMDD(stt)=#{date} group by province_name ")
    List<ProvinceBean> selectProGmv(Integer date);
}
